package com.demo.mapper;

import com.demo.pojo.Customer;

import java.util.List;
import java.util.Map;

public interface CustomerMapper {
    //直接用SQL拼接
    List<Customer> findByNameAndJobs(Customer customer);

    List<Customer> findByNameOrJobs(Customer customer);

    //用where标签生成查询条件
    List<Customer> findByNameAndJobs2(Customer customer);

    //用trim标签生成查询条件
    List<Customer> findByNameAndJobs3(Customer customer);

    int updateBySet(Customer customer);

    int updateBySet2(Customer customer);

    List<Customer> findByArray(int[] ids);

    List<Customer> findByNameArray(String[] names);

    List<Customer> findByList(List<Integer> ids);

    List<Customer> findByMap(Map map);
}
